home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
SGI Freeware 1998 November
/
Freeware November 1998.img
/
dist
/
fw_msql.idb
/
usr
/
freeware
/
msql
/
tests
/
cachetest.z
/
cachetest
Wrap
Text File
|
1998-10-27
|
3KB
|
103 lines
#!/bin/sh
#
# This script beats the internal table caching code around the ears a
# few times. It constantly forces the caches to be rolled and
# reloaded. Run it using "cachetest dbname" where dbname is a database
# that exists and doesn't have tables called test1 test2 or test3 in it.
#
# bambi
CREATE1="create table test1 ( name char(40), num int)"
CREATE2="create table test2 ( name char(40), num int)"
CREATE3="create table test3 ( name char(40), num int )"
CREATE4="create table test4 ( name char(40), num int)"
CREATE5="create table test5 ( name char(40), num int)"
CREATE6="create table test6 ( name char(40), num int)"
CREATE7="create table test7 ( name char(40), num int)"
CREATE8="create table test8 ( name char(40), num int)"
CREATE9="create table test9 ( name char(40), num int)"
CREATE10="create table test10 ( name char(40), num int)"
DROP1="drop table test1"
DROP2="drop table test2"
DROP3="drop table test3"
DROP4="drop table test4"
DROP5="drop table test5"
DROP6="drop table test6"
DROP7="drop table test7"
DROP8="drop table test8"
DROP9="drop table test9"
DROP10="drop table test10"
INSERT1="insert into test1 values ('Test1',1)"
INSERT2="insert into test2 values ('Test2',2)"
INSERT3="insert into test3 values ('Test3',3)"
INSERT4="insert into test4 values ('Test4',4)"
INSERT5="insert into test5 values ('Test5',5)"
INSERT6="insert into test6 values ('Test6',6)"
INSERT7="insert into test7 values ('Test7',7)"
INSERT8="insert into test8 values ('Test8',8)"
INSERT9="insert into test9 values ('Test9',9)"
INSERT10="insert into test10 values ('Test10',10)"
NUM_CYCLES=40
COUNT=0
INDEX=1
DB=$1
if test "$DB." = "."
then
echo
echo "Bad usage. Please read the intro to the script."
echo
exit 1
fi
(
echo "$DROP1 \p\g"
echo "$DROP2 \p\g"
echo "$DROP3 \p\g"
echo "$DROP4 \p\g"
echo "$DROP5 \p\g"
echo "$DROP6 \p\g"
echo "$DROP7 \p\g"
echo "$DROP8 \p\g"
echo "$DROP9 \p\g"
echo "$DROP10 \p\g"
echo "$CREATE1 \p\g"
echo "$CREATE2 \p\g"
echo "$CREATE3 \p\g"
echo "$CREATE4 \p\g"
echo "$CREATE5 \p\g"
echo "$CREATE6 \p\g"
echo "$CREATE7 \p\g"
echo "$CREATE8 \p\g"
echo "$CREATE9 \p\g"
echo "$CREATE10 \p\g"
echo "$INSERT1 \p\g"
echo "$INSERT2 \p\g"
echo "$INSERT3 \p\g"
echo "$INSERT4 \p\g"
echo "$INSERT5 \p\g"
echo "$INSERT6 \p\g"
echo "$INSERT7 \p\g"
echo "$INSERT8 \p\g"
echo "$INSERT9 \p\g"
echo "$INSERT10 \p\g"
while test $COUNT -lt $NUM_CYCLES
do
echo "select * from test1 \p\g"
echo "select * from test5 \p\g"
echo "select * from test2 \p\g"
echo "select * from test6 \p\g"
echo "select * from test3 \p\g"
echo "select * from test7 \p\g"
echo "select * from test4 \p\g"
echo "select * from test8 \p\g"
echo "select * from test10 \p\g"
echo "select * from test9 \p\g"
COUNT=`expr $COUNT + 1`
done
) | ../bin/msql $DB